I everyone in this lecture will learn about some important keyboard shortcuts using shortcuts especially
when you're doing a standard formatting or repetitive actions in Excel shortcuts increase your efficiency
and reduce the time taken.
You'd need not double between keyboard and mouse.
We need not take your mouse to a particular button in the menu.
Just tap some keystrokes on keyboard and your job is done.
So let us look at some basic shortcuts first let's first learn about the moment ventilation corporates
which added an additional shortcut.
From one side to another if you want to move your selected cell you can just have the arrow keys.
If you want to move left tabular karaoke moves on trade later.
If you want to go to the end of a continuous range.
So if you are on student and if you want to go to sites grade directly your first take control key and
body type direction D.
Similarly to go down at the end of the continuous table you doubly control key and prestige down the
if you want to move one screen down so there is a Page Down button you can conduct if you click on page
up again you'll move to the upper page if you want to move from left to left and right.
That's the old key and first page down.
If you click on page it up a little more to the left side of the screen.
I want to go to the first cell in this row.
Just press the home button if you want to go to the first cell of the sheet you press control and then
the home button next if you want to select a range in this table.
So you go to student first and if you want to select the match school and this to the name you start
selecting by tapping on shift and moving with video then it changes
will go down to select match marks but if I want to select the whole it will adjust tab control shift
and press the lady look slim the whole table but I think control will take you to the end of that table
having shift also pressed.
We select that cell which you are navigating.
If you wanted to select the table on as a whole you can just press control and a select all parts of
the table in one go to move to the next worksheet.
There is also a shortcut you can press control and page down you can see that you have moved to the
next sheet the move to the previous sheet you press control and Page up
next.
Let us look at some basic editing shortcuts which I think are copy paste output.
If you want to get this all table and want to pasted below this again they will you select your level
using control a press control X to go below the second level and press control.
You can see that the whole table is cut and pasted below descend into the if you are not happy with
what you have done and you want to undo it just click on project and you'll see that detail moves back
to its original position to copy this table and paste it somewhere else.
You again select this whole table to control see the table is copied and pasted anywhere you want.
Please note while pasting the formulas remain intact so in the first table if it was G5 then equal to
75 in this drivel it will be gate 22.
Excel has by itself increased the cell number in every formula in M5.
It was written G5.
So in order to do it it has automatically implemented it to do it or do it you know this control G.
And if you want to redo it you can do that controlled by
so that are new and redo for you will undo this.
I have copied that table and write pasting.
You can see there are still some formulas.
If I want to paste the values of the whole label I just by pasting I just select special auctions to
do that.
Instead of control me.
You do control only
you'll see these these special options.
If you want values you gain tab on V also which is underline for values.
What format to gain tab on B for formula.
Again tab on F and I would select values and click on OK if you go down you can see that under the mat
grade I learned there were formulas now disputed as values although it has not copied the formatting
of this table.
You have to be formatted or if you wanted to take the formatting also you have to select me format option
while pasting I'LL CLEAR THIS.
NOW LET'S LEARN HOW TO SAVE OUR FATE using a shortcut.
We can continuously say what file we are working by just typing uncontrolled s whenever I type on controller's
executives file.
Okay.
If I want to work on a new file I can type on control and
you can see there is a new file open up I can close this to bring the sheet as a shortcut it just control
B.
It opens up the print preview and selective printing option then click on print button to find a path
to fill a void in the sheet.
You can use the fine option which is control if you want to.
So a student once they click on my next.
You click on bionics again.
To the value of student 1 excluded.
Let your guard celebrating options if I click about reversal it selects their tail.
What if I want to edit this value in to say I flick on f 2.
You can see that now you can change the value listen
if I want to do a spellcheck in any of this I'll let the tool and type on F seven.
That takes the spelling.
If there is a wrong spelling error you highlight that.
So for example if I tried to Ben
so to check the spelling here I'll just tap on Epsilon and then see that Excel is suggesting that it
should be student like change.
Yes laws that she died at is going to do next.
If I want to look at all the formulas in this sheet to do that there's a shortcut.
You just tap on control and then click dip delay but then which is the button below the escapee.
Now if you go up and see that data form let it in.
It's visible to go back to the earlier version pest control and then let him.
And you can now see the values instead of on loans.
Now in Excel if you press out key you can see that all the menu options are assigned an alphabet.
I think that it will take you to that particular menu item so pressing it has taken us to form.
This opens up all options in the form of shortcuts and whichever option you use very often you can just
remember the shortcut to that option for example very often I change the root of the columns to do this.
Let us first find out the shortcut.
I've already done hard Ed to go to the homes menu within home.
I want to go to the format option which is highlighted as all
within format.
If I want to retain the column it looks like W and I'll update this too if you can see that column rate
has increased to 15.
So now I know the shortcut which is old age or w whenever I want to increase the rate of any cell at
industrial electrical to increase the rate of mad scientist English columns.
I just press or a George W. and I 15.
Okay.
You can see that I've increased the celibate very quickly.
So instead of telling you all this shortcut you can just find out every shortcut on your own.
And just remember these charters that you will actually use it to.
Just before you do commonly use shortcut must look at the formatting shortcut if you want to italicized
these T cells that are then it then do as I use.
I like it two.
You can see that these three are italicized now to increase the font size of these three or H F G so
the font size of these T cells have now increased to left the ninety three.
Well again two are at a and then.
I have done the right alignment to left a line.
You can do all that.
A a similar lead for data item also.
You can use shortcuts type or what data you can see it is a or 8 then to apply a filter you can press
B you can see you filter features that applied.
Now in this shoot we have already removed degree length if you want to show the great lines you tap
on w W-4 view and then V and then G for grid length.
You can see that degree line combat if you want to remove them back to or w we g liberal end removed.
Now if you want to freely paint you have only discussed what freezing pains means.
So if if I want to freeze the being above and on the left off J five cell you select this in.
That's all W F and F again you can see that the row above left row and the column to the left of J column
are frozen in that position.
Let's go another shortcut on your own.
That's all for this lecture in the next lecture.
We will look at some data analysis techniques in Excel thanks.